/*
 Navicat Premium Dump SQL

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 80040 (8.0.40)
 Source Host           : localhost:3306
 Source Schema         : vben_cloud

 Target Server Type    : MySQL
 Target Server Version : 80040 (8.0.40)
 File Encoding         : 65001

 Date: 27/02/2025 17:59:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for playground_score
-- ----------------------------
DROP TABLE IF EXISTS `playground_score`;
CREATE TABLE `playground_score` (
  `id` bigint NOT NULL,
  `name` varchar(20) NOT NULL,
  `code` varchar(50) NOT NULL,
  `chinese` decimal(5,2) DEFAULT NULL,
  `math` decimal(5,2) DEFAULT NULL,
  `english` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of playground_score
-- ----------------------------
BEGIN;
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1894771740200116226, '张三', 'S2024088', 88.00, 85.00, 92.00);
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1894774619870810114, '孙悟空', '20010906', 87.00, 90.00, 92.00);
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1894775781139357698, '猪八戒', '2019110', 60.00, 70.00, 80.00);
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1894784647948275714, '沙湿地', '20191102', 66.00, 99.00, 77.00);
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1894786531815800833, '唐三藏', '111111', 99.00, 99.00, 99.00);
INSERT INTO `playground_score` (`id`, `name`, `code`, `chinese`, `math`, `english`) VALUES (1895040912310607874, '雪豹', '111222', 44.00, 11.00, 22.00);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '唯一编码',
  `pids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父ID集合',
  `type` int DEFAULT NULL COMMENT '菜单类型<sys_menu_type>',
  `sort` bigint DEFAULT '999' COMMENT '排序',
  `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路由地址',
  `component` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件地址',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单图标',
  `is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示',
  `is_link` tinyint(1) DEFAULT NULL COMMENT '是否链接',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '外部链接地址',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '是否启用',
  `open_type` int DEFAULT NULL COMMENT '打开方式<sys_menu_open_type>',
  `is_cache` tinyint(1) DEFAULT NULL COMMENT '是否缓存',
  `is_sync` tinyint(1) DEFAULT '1' COMMENT '是否同步',
  `variable` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '额外参数JSON',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新用户',
  `del_flag` char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`menu_id`) USING BTREE,
  KEY `idx_sys_menu_code` (`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `role_name` varchar(64) DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(64) DEFAULT NULL COMMENT '角色编码',
  `role_desc` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `create_by` varchar(64) NOT NULL DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) NOT NULL DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  PRIMARY KEY (`role_id`) USING BTREE,
  KEY `role_idx1_role_code` (`role_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1, '管理员', 'admin', '管理员', '', 'admin', '2017-10-29 15:45:51', '2025-02-21 14:52:31', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (2, '普通用户', 'user', '普通用户', '', 'admin', '2022-03-31 17:03:15', '2025-02-21 14:52:34', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1893199607313903617, '游客', 'tourist', '游客账号', '1', '1', '2025-02-22 15:22:15', '2025-02-22 15:53:15', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1893199763719499777, '演示', 'demo', '演示账号', '1', '1', '2025-02-22 15:22:52', '2025-02-22 15:53:24', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1893199847425224706, '演示', 'demo1', NULL, '1', '1', '2025-02-22 15:23:12', '2025-02-22 15:48:19', '1');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`) VALUES (1893200040510009346, '演示', 'demo2', '演示', '1', '1', '2025-02-22 15:23:58', '2025-02-22 15:48:12', '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `username` varchar(64) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `salt` varchar(255) DEFAULT NULL COMMENT '盐值',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `nickname` varchar(64) DEFAULT NULL COMMENT '昵称',
  `name` varchar(64) DEFAULT NULL COMMENT '姓名',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱地址',
  `dept_id` bigint DEFAULT NULL COMMENT '所属部门ID',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `lock_flag` char(1) DEFAULT '0' COMMENT '锁定标记，0未锁定，9已锁定',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  `wx_openid` varchar(32) DEFAULT NULL COMMENT '微信登录openId',
  `qq_openid` varchar(32) DEFAULT NULL COMMENT 'QQ openId',
  `gitee_login` varchar(100) DEFAULT NULL COMMENT '码云标识',
  `osc_id` varchar(100) DEFAULT NULL COMMENT '开源中国标识',
  `last_login_time` datetime DEFAULT NULL COMMENT '上次登陆时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  KEY `user_wx_openid` (`wx_openid`) USING BTREE,
  KEY `user_qq_openid` (`qq_openid`) USING BTREE,
  KEY `user_idx1_username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `phone`, `avatar`, `nickname`, `name`, `email`, `dept_id`, `create_by`, `update_by`, `create_time`, `update_time`, `lock_flag`, `del_flag`, `wx_openid`, `qq_openid`, `gitee_login`, `osc_id`, `last_login_time`) VALUES (1, 'admin', '$2a$10$tJSyJjGRqflsuVD7ta/2uuXzZlEjtn76B.PmhL.ZyczcTpWPNEyNe', NULL, '17867283307', 'https://hututu-prod-1320667610.cos.ap-beijing.myqcloud.com/public/1881752164258402305/2025-01-22_vPZVSQz6n197LPj1.png', '管理员', '孙靖', 'sunnmaster001@gmail.com', NULL, NULL, '1', '2025-02-16 15:23:22', '2025-02-26 08:21:01', '0', '0', NULL, NULL, NULL, NULL, '2025-02-26 08:21:00');
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `phone`, `avatar`, `nickname`, `name`, `email`, `dept_id`, `create_by`, `update_by`, `create_time`, `update_time`, `lock_flag`, `del_flag`, `wx_openid`, `qq_openid`, `gitee_login`, `osc_id`, `last_login_time`) VALUES (1891120977682763778, '17867283307', '$2a$10$vgRfymJXn8AtCzFt.hhrHuCoMxcMK.Dh.klWd98/VTlTsg4VuMX/S', NULL, '17867283307', 'https://hututu-prod-1320667610.cos.ap-beijing.myqcloud.com/public/1881752164258402305/2025-01-22_AkXtG9ABoHFIuJyH.png', '17867283307', '孙闹', NULL, NULL, NULL, '1', '2025-02-16 21:42:31', '2025-02-22 23:37:25', '0', '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `phone`, `avatar`, `nickname`, `name`, `email`, `dept_id`, `create_by`, `update_by`, `create_time`, `update_time`, `lock_flag`, `del_flag`, `wx_openid`, `qq_openid`, `gitee_login`, `osc_id`, `last_login_time`) VALUES (1891511811456589825, '13346485425', '$2a$10$yReqcVKXN.tH6v.WChabmu5PpcfaA7iEOKqpcav7x2N.953t5UN1y', NULL, '13346485425', 'https://hututu-prod-1320667610.cos.ap-beijing.myqcloud.com/public/1881752164258402305/2025-01-22_AkXtG9ABoHFIuJyH.png', '13346485425', NULL, NULL, NULL, NULL, '1', '2025-02-17 23:35:33', '2025-02-22 14:04:04', '0', '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `phone`, `avatar`, `nickname`, `name`, `email`, `dept_id`, `create_by`, `update_by`, `create_time`, `update_time`, `lock_flag`, `del_flag`, `wx_openid`, `qq_openid`, `gitee_login`, `osc_id`, `last_login_time`) VALUES (1892956003655446529, 'sunnao', '$2a$10$NZXuAeWHxBYri5kIUEyCMOCgRAhmhKn3YCYeVwV0tO1oRS.ZUQRge', NULL, '17867283306', NULL, '大飞侠', '孙靖', 'sunnmaster001@gmail.com', NULL, '1', '1', '2025-02-21 23:14:15', '2025-02-22 23:27:12', '0', '1', NULL, NULL, NULL, NULL, '2025-02-22 14:09:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_login_log`;
CREATE TABLE `sys_user_login_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `username` varchar(64) NOT NULL COMMENT '用户名',
  `login_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '登录时间',
  `logout_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否离线(0否 1是)',
  `logout_time` datetime DEFAULT NULL COMMENT '离线时间',
  `client_ip` varchar(45) DEFAULT NULL COMMENT '客户端IP',
  `device_info` varchar(255) DEFAULT NULL COMMENT '设备信息',
  `browser_info` varchar(255) DEFAULT NULL COMMENT '浏览器信息',
  `login_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '登录状态：0失败，1成功',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT ' ' COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT ' ' COMMENT '修改人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '删除标记，0未删除，1已删除',
  `login_id` varchar(255) NOT NULL COMMENT '登陆id (唯一标识一次登陆活动)',
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1894543151467741185 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户登录日志表';

-- ----------------------------
-- Records of sys_user_login_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892481250654650368, 1, 'admin', '2025-02-20 15:47:45', '1', '2025-02-20 15:49:08', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 15:47:45', '2025-02-20 15:49:08', '0', '1892481249438302208');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892481903372238848, 1, 'admin', '2025-02-20 15:50:21', '1', '2025-02-20 15:51:15', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 15:50:21', '2025-02-20 15:51:15', '0', '1892481902696955904');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892482233677873152, 1, 'admin', '2025-02-20 15:51:40', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 15:51:40', '2025-02-20 15:51:40', '0', '1892482233002590208');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892482989164298240, 1, 'admin', '2025-02-20 15:54:40', '1', '2025-02-20 15:54:48', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 15:54:40', '2025-02-20 15:54:48', '0', '1892482988434489344');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892483392471793664, 1, 'admin', '2025-02-20 15:56:16', '1', '2025-02-20 15:56:23', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 15:56:16', '2025-02-20 15:56:23', '0', '1892483391809093632');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892565216711069696, 1, 'admin', '2025-02-20 21:21:24', '1', '2025-02-21 22:50:15', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-20 21:21:24', '2025-02-21 22:50:15', '0', '1892565215586996224');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892949982916542464, 1, 'admin', '2025-02-21 22:50:20', '1', '2025-02-21 22:51:29', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:50:20', '2025-02-21 22:51:29', '0', '1892949982283202560');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892950306511290368, 1, 'admin', '2025-02-21 22:51:37', '1', '2025-02-21 22:52:40', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:51:37', '2025-02-21 22:52:40', '0', '1892950305852784640');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892950585277317120, 1, 'admin', '2025-02-21 22:52:44', '1', '2025-02-21 22:56:12', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:52:44', '2025-02-21 22:56:12', '0', '1892950584639782912');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892951475300237312, 1, 'admin', '2025-02-21 22:56:16', '1', '2025-02-21 22:56:18', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:56:16', '2025-02-21 22:56:18', '0', '1892951474683674624');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892951497928507392, 1, 'admin', '2025-02-21 22:56:21', '1', '2025-02-21 22:57:00', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:56:21', '2025-02-21 22:57:00', '0', '1892951497320333312');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1892951830259990528, 1, 'admin', '2025-02-21 22:57:40', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-21 22:57:40', '2025-02-21 22:57:40', '0', '1892951829056225280');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893127959135219712, 1, 'admin', '2025-02-22 10:37:33', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:37:33', '2025-02-22 10:37:33', '0', '1893127958359273472');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128009429118976, 1, 'admin', '2025-02-22 10:37:45', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:37:45', '2025-02-22 10:37:45', '0', '1893128009328455680');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128024608305152, 1, 'admin', '2025-02-22 10:37:48', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:37:48', '2025-02-22 10:37:48', '0', '1893128024499253248');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128044195704832, 1, 'admin', '2025-02-22 10:37:53', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:37:53', '2025-02-22 10:37:53', '0', '1893128044099235840');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128081025888256, 1892956003655446529, 'sunnao', '2025-02-22 10:38:02', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:02', '2025-02-22 10:38:02', '0', '1893128080895864832');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128230842232832, 1892956003655446529, 'sunnao', '2025-02-22 10:38:38', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:38', '2025-02-22 10:38:38', '0', '1893128230749958144');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128272198070272, 1, 'admin', '2025-02-22 10:38:47', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:47', '2025-02-22 10:38:47', '0', '1893128272084824064');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128290686562304, 1, 'admin', '2025-02-22 10:38:52', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:52', '2025-02-22 10:38:52', '0', '1893128290577510400');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128306431979520, 1, 'admin', '2025-02-22 10:38:56', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:56', '2025-02-22 10:38:56', '0', '1893128306331316224');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128321581805568, 1, 'admin', '2025-02-22 10:38:59', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', '1', '1', '2025-02-22 10:38:59', '2025-02-22 10:38:59', '0', '1893128321476947968');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893128456915189760, 1, 'admin', '2025-02-22 10:39:31', '1', '2025-02-22 10:49:45', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 10:39:31', '2025-02-22 10:49:45', '0', '1893128456273461248');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893131052744744960, 1, 'admin', '2025-02-22 10:49:50', '1', '2025-02-22 10:52:49', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 10:49:50', '2025-02-22 10:52:49', '0', '1893131052245622784');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893131828594532352, 1, 'admin', '2025-02-22 10:52:55', '1', '2025-02-22 10:55:54', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 10:52:55', '2025-02-22 10:55:54', '0', '1893131828162519040');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893132592985489408, 1, 'admin', '2025-02-22 10:55:58', '1', '2025-02-22 11:23:14', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 10:55:58', '2025-02-22 11:23:14', '0', '1893132592561864704');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893139482842812416, 1, 'admin', '2025-02-22 11:23:20', '1', '2025-02-22 13:39:30', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 11:23:20', '2025-02-22 13:39:30', '0', '1893139482419187712');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893173827523674112, 1, 'admin', '2025-02-22 13:39:49', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:39:49', '2025-02-22 13:39:49', '0', '1893173766903398400');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893174326176088064, 1, 'admin', '2025-02-22 13:41:47', '1', '2025-02-22 13:42:48', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:41:48', '2025-02-22 13:42:48', '0', '1893174325853126656');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893174610025619456, 1, 'admin', '2025-02-22 13:42:55', '1', '2025-02-22 13:44:15', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:42:55', '2025-02-22 13:44:15', '0', '1893174609509720064');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893174960233160704, 1, 'admin', '2025-02-22 13:44:19', '1', '2025-02-22 13:44:52', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:44:19', '2025-02-22 13:44:52', '0', '1893174959767592960');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893175128143749120, 1, 'admin', '2025-02-22 13:44:59', '1', '2025-02-22 13:48:36', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:44:59', '2025-02-22 13:48:36', '0', '1893175127623655424');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893176054346776576, 1, 'admin', '2025-02-22 13:48:40', '1', '2025-02-22 13:49:16', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:48:40', '2025-02-22 13:49:16', '0', '1893176053877014528');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893176220906749952, 1, 'admin', '2025-02-22 13:49:19', '1', '2025-02-22 13:54:49', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:49:19', '2025-02-22 13:54:49', '0', '1893176220483125248');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893177620063662080, 1, 'admin', '2025-02-22 13:54:53', '1', '2025-02-22 13:56:02', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:54:53', '2025-02-22 13:56:02', '0', '1893177619547762688');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893177945805885440, 1, 'admin', '2025-02-22 13:56:10', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', NULL, NULL, '2025-02-22 13:56:10', '2025-02-22 13:56:10', '0', '1893177945642307584');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893178055101042688, 1, 'admin', '2025-02-22 13:56:37', '1', '2025-02-22 13:57:12', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:56:37', '2025-02-22 13:57:12', '0', '1893178053716922368');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893178226870374400, 1, 'admin', '2025-02-22 13:57:17', '1', '2025-02-22 14:09:15', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 13:57:18', '2025-02-22 14:09:16', '0', '1893178226123788288');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181284681580544, 1892956003655446529, 'sunnao', '2025-02-22 14:09:27', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', NULL, NULL, '2025-02-22 14:09:27', '2025-02-22 14:09:27', '0', '1893181284174069760');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181311067947008, 1892956003655446529, 'sunnao', '2025-02-22 14:09:33', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', NULL, NULL, '2025-02-22 14:09:33', '2025-02-22 14:09:33', '0', '1893181310577213440');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181343586385920, 1892956003655446529, 'sunnao', '2025-02-22 14:09:41', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', NULL, NULL, '2025-02-22 14:09:41', '2025-02-22 14:09:41', '0', '1893181343062097920');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181362150375424, 1892956003655446529, 'sunnao', '2025-02-22 14:09:45', '1', '2025-02-22 14:11:29', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1892956003655446529', '1892956003655446529', '2025-02-22 14:09:45', '2025-02-22 14:11:29', '0', '1893181361382817792');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181850405109760, 1892956003655446529, 'sunnao', '2025-02-22 14:11:41', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '0', NULL, NULL, '2025-02-22 14:11:41', '2025-02-22 14:11:41', '0', '1893181850262503424');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893181910673063936, 1, 'admin', '2025-02-22 14:11:56', '1', '2025-02-22 17:05:50', '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 14:11:56', '2025-02-22 17:05:50', '0', '1893181909888729088');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893225764755427328, 1, 'admin', '2025-02-22 17:06:11', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 17:06:11', '2025-02-22 17:06:11', '0', '1893225763987869696');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1893312409612984320, 1, 'admin', '2025-02-22 22:50:29', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-22 22:50:29', '2025-02-22 22:50:29', '0', '1893312408350498816');
INSERT INTO `sys_user_login_log` (`log_id`, `user_id`, `username`, `login_time`, `logout_flag`, `logout_time`, `client_ip`, `device_info`, `browser_info`, `login_status`, `create_by`, `update_by`, `create_time`, `update_time`, `del_flag`, `login_id`) VALUES (1894543151467741184, 1, 'admin', '2025-02-26 08:21:01', '0', NULL, '0:0:0:0:0:0:0:1', 'OSX', 'Chrome', '1', '1', '1', '2025-02-26 08:21:01', '2025-02-26 08:21:01', '0', '1894543150486274048');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1892956003655446529, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
